/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 316

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 55 50 44 41 54 45 20 48 | 45 41 44 45 52 00 63 72 |UPDATE H|EADER.cr|
|00000010| 65 61 74 65 20 74 72 69 | 67 67 65 72 20 74 25 31 |eate tri|gger t%1|
|00000020| 41 63 74 69 6f 6e 5f 25 | 32 37 54 61 62 6c 65 4e |Action_%|27TableN|
|00000030| 61 6d 65 20 6f 6e 20 25 | 54 61 62 6c 65 4e 61 6d |ame on %|TableNam|
|00000040| 65 20 66 6f 72 20 25 41 | 63 74 69 6f 6e 20 61 73 |e for %A|ction as|
|00000050| 0d 0a 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 |../* ERw|in Built|
|00000060| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|00000070| 0a 2f 2a 20 25 41 63 74 | 69 6f 6e 20 74 72 69 67 |./* %Act|ion trig|
|00000080| 67 65 72 20 6f 6e 20 25 | 54 61 62 6c 65 4e 61 6d |ger on %|TableNam|
|00000090| 65 20 2a 2f 0d 0a 62 65 | 67 69 6e 0d 0a 20 20 64 |e */..be|gin..  d|
|000000a0| 65 63 6c 61 72 65 20 20 | 40 6e 75 6d 72 6f 77 73 |eclare  |@numrows|
|000000b0| 20 69 6e 74 2c 0d 0a 20 | 20 20 20 20 20 20 20 20 | int,.. |        |
|000000c0| 20 20 40 6e 75 6c 6c 63 | 6e 74 20 69 6e 74 2c 0d |  @nullc|nt int,.|
|000000d0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 40 76 61 6c |.       |    @val|
|000000e0| 69 64 63 6e 74 20 69 6e | 74 2c 0d 0a 20 20 20 20 |idcnt in|t,..    |
|000000f0| 20 20 20 20 20 20 20 25 | 50 4b 44 65 63 6c 28 2c |       %|PKDecl(,|
|00000100| 40 69 6e 73 29 25 64 65 | 63 6c 28 62 43 6f 6d 6d |@ins)%de|cl(bComm|
|00000110| 61 2c 30 29 25 46 6f 72 | 45 61 63 68 41 74 74 28 |a,0)%For|EachAtt(|
|00000120| 29 20 7b 25 69 66 28 25 | 41 74 74 49 73 50 6b 29 |) {%if(%|AttIsPk)|
|00000130| 20 7b 25 3d 28 62 43 6f | 6d 6d 61 2c 31 29 7d 20 | {%=(bCo|mma,1)} |
|00000140| 7d 25 69 66 20 28 25 3d | 3d 28 25 3a 62 43 6f 6d |}%if (%=|=(%:bCom|
|00000150| 6d 61 2c 31 29 29 20 7b | 2c 7d 0d 0a 20 20 20 20 |ma,1)) {|,}..    |
|00000160| 20 20 20 20 20 20 20 40 | 65 72 72 6e 6f 20 20 20 |       @|errno   |
|00000170| 69 6e 74 2c 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |int,..  |        |
|00000180| 20 40 65 72 72 6d 73 67 | 20 20 76 61 72 63 68 61 | @errmsg|  varcha|
|00000190| 72 28 32 35 35 29 0d 0a | 0d 0a 20 20 73 65 6c 65 |r(255)..|..  sele|
|000001a0| 63 74 20 40 6e 75 6d 72 | 6f 77 73 20 3d 20 40 40 |ct @numr|ows = @@|
|000001b0| 72 6f 77 63 6f 75 6e 74 | 00 28 27                |rowcount|.('     |
+--------+-------------------------+-------------------------+--------+--------+